#include "WorkingDialog.h" void SgeSetCallDetail(pSgeWorkCallData p, int cache_flag, void* cache_key, int index_type, void* index_value, void* index_key, int queue_file_flag);
If p is NULL, no action is taken.
The parameter cache_flag specifies how the cache is used.Valid values are given by the defined constants:
These indicate the cache is not used and the stored procedure or DSQL object is run on the database server, the stored procedure or DSQL object is run on the database server and stored in the cache, or the data is retrieved from the client's cache and not run on the Server, respectively.NO_CACHETO_CACHEFROM_CACHE
The parameter cache_key specifies which cache to use. If NULL, the stored procedure or DSQL object triplet determines the cache. This is not used if NO_CACHE is specified as the cache_flag.
The parameter index_type specifies what kind of index to use for FROM_CACHE operations. Valid values are given by the defined constants:
ROW_INDEX (specifies row number, 0 relative)WIDGET_INDEX (the widget determines and updates index value)NEXT_INDEX (increment index value)PREV_INDEX (decrement index value)PAGEUP_INDEX (decrement index value by page size)PAGEDW_INDEX (increment index value by page size)HOME_INDEX (set index value to 0)LAST_INDEX (set index value to number of rows in cache minus 1).index_value is interpreted and used according to the index type. For a ROW_INDEX, the value is the row desired. For a WIDGET_INDEX, the value must be a valid Widget or NULL. For PAGEUP_INDEX and PAGEDOWN_INDEX, the value specifies the page size. If the page size is not greater than 1, a default of 20 is used. For the other index types, the index value is not used.
The parameter index_key specifies which index or iterator for that cache item. Multiple indices are possible. The queue_file_flag is not yet implemented. Valid constants are:
If this function is not used then NO_CACHE and NO_QUEUE_FILE are used and the remaining are not used when executing the stored procedure or DSQL object.NO_QUEUE_FILEQUEUE_TO_FILE
pSgeWorkCallData pSgeWCD; .... SgeSetCallDetail(pSgeWCD, FROM_CACHE, 0, ROW_INDEX, 2, 0, NO_QUEUE_FILE);